<Source>.DataSourceKnown (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

New WINDEV and WINDEV Mobile 2024 feature!

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

How to initialize a data source

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.DataSourceKnown (Function)

In french: <Source>.SourceDeDonnéesConnue

Determines if a data source has been initialized. This function prevents errors such as "You called XXX . The YYY data source has not been initialized".

Difference with <Source>.QueryExecuted: <Source>.DataSourceKnown determines if the data source is known to the HFSQL engine, regardless of its content. <Source>.QueryExecuted can only be used with queries.

Example

MaVue is Data Source
// MaVue est associée à une vue

IF MaVue.SourceDeDonnéesConnue() = False THEN
	// Initialisation de la variable MaVue 
	MaVue.CréeVue(CLIENT, "*", "NOM,VILLE", "NOM]='A'", hViewDefault)
END

Syntax

<Result> = <Data source to check>.DataSourceKnown()

<Result>: Boolean

True if the data source has been initialized,
False otherwise. HErrorInfo returns more details about the problem.

<Data source to check>: Data Source variable

Data Source variable to be checked. This data source can correspond to:
an external data file,
an SQL query,
a view.

Remarks

How to initialize a data source

The method used to initialize a data source depends on its content:

External data file: you must use <Source>.DeclareExternal.
Query and SQL query: you must use <Source>.ExecuteQuery, <Source>.ExecuteSQLQuery, etc.
HFSQL view: You must use <Source>.CreateView.

For more details, see the help page on the Data Source variable type.

Business / UI classification: Business Logic

Component: wd290hf.dll